import xlrd
import xlwt
import SeleniumTest.common.HttpTestLog as logs
import pandas

xlFilePath = "../testCase/TestCase.xlsx"
log = logs.Log.get_log(__name__)
def get_para_from_excel():
    try:
        xlFile = pandas.read_excel(xlFilePath,header=3)#前四行作为header，不参与读取
        parm_list = xlFile.loc[:,["search_type","inner_propert","name","act_name","value"]].values#搜索所有行的列表内字段的值，返回列表
    except(SystemExit, KeyboardInterrupt):
        raise
    except Exception as err:
        log.error("something wrong!", exc_info=True)
    else:
        return parm_list

if __name__ == '__main__':
    para = get_para_from_excel()
    for i in para:
        for j in i:
            if pandas.isnull(j):
                print("asdafsaxcv")
            print(j)
    print(pandas.isnull(para))
